<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class User_model extends CI_Model {

	function __construct()
	{
		parent::__construct();
    }

	function getDataLogin($username)
	{
	    $query = "SELECT v.*,p.nama AS NAMA_PRODI
                  FROM view_pass_mahasiswa v, prodi p
                  WHERE `NIM`='".$username."' AND `LEVEL`=5 AND v.PRODI = p.KODE";

        $query = $this->db->query($query);

        return $query;
	}
}

